SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596168 LIMIT 1 [ RunTime:0.000638s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596168 [ RunTime:0.002544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368319,288583,677780,117695,1002079,14032,264079,338919,989395,975222,991652,48695,258138,790954,641531,10894,202445,1015794,660747,943847,465737,961066,1027570,120414,158179,679347,445418,119591,5957,482224,214686,774371,620516,767516,343189,302634,78566,12334,369666,306699,128964,533110,464981,404076,932276,912361,793845,955192,627752,592489,844366,44833,106849,591093,316461,607903,750116,530625,63467,576783) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003797s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596168 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596168 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]