SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546807 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546807 [ RunTime:0.001578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425834,691410,132517,884824,288228,872946,698544,926236,315675,270760,460055,1044640,898189,242034,319694,620330,636531,813465,107339,788048,655857,960739,289753,437915,444366,457941,92357,546444,9335,141852,990323,62685,1006106,187914,659081,921614,479081,795380,404967,300882,10066,486613,531021,649604,623393,305917,319925,151509,830551,574362,438034,970062,93797,916226,761462,530758,412531,878062,583704,506302) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546807 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546807 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]