SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392671 LIMIT 1 [ RunTime:0.002713s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392671 [ RunTime:0.002875s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525191,114983,298348,197693,386008,724985,331553,82574,620889,318748,479682,638604,496958,306574,1021134,569815,868619,481718,374996,875734,726523,230263,229313,479404,776792,298043,435404,235082,177443,685856,992722,1025412,827120,154804,269075,840773,1035428,693707,977410,388321,82622,142843,153740,977605,797860,492428,790061,376386,664534,678533,64598,535084,683527,890709,49582,467837,767040,743566,928891,674015) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]