SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 33161 LIMIT 1 [ RunTime:0.000484s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 33161 [ RunTime:0.002246s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292203,529188,941816,929194,375045,38159,205634,910161,311480,47400,913312,447619,181559,576327,424358,7811,1030668,686753,968912,954799,256439,781955,994314,309843,345923,235040,513267,420941,337375,146497,942818,16556,252843,942345,328459,693091,381198,687913,211138,912384,939289,625490,227237,111514,932283,867135,673686,171402,381312,497313,941233,658729,332931,313939,620028,798790,232472,370873,831394,980841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 33161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 33161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]