SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507499 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507499 [ RunTime:0.004075s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (16060,827602,258906,966922,339646,1002175,403273,526800,659652,217128,887505,54127,313303,612402,418366,472764,959404,798763,412166,32105,199380,781843,83748,725720,917297,240021,528100,77592,603886,914458,93068,416092,78615,916093,531509,68416,37302,503125,832425,158373,508437,941115,801363,486390,408565,180480,611362,651349,40546,1001264,992954,638470,219854,374305,39087,909643,554122,571914,259865,777284) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000394s ]