SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004436s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451405 LIMIT 1 [ RunTime:0.003074s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451405 [ RunTime:0.005807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (780063,288248,878641,20416,865918,546117,86245,971877,903092,352061,963581,972170,503657,1015437,948790,306256,346481,380071,390071,328383,205458,252237,112505,341191,968742,178382,935796,865524,601091,861865,343207,868584,753373,169738,647842,40569,582049,394754,723566,58877,468446,699955,227894,533553,28223,371147,558469,590896,532671,947297,870334,963389,85084,35943,91903,151657,599972,124072,353389,794014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001918s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003314s ]