SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555699 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555699 [ RunTime:0.003724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41810,740109,442851,578072,298192,532732,1042435,638934,210469,619683,194157,73182,201934,214014,296784,14747,110935,177610,49659,316261,136429,948439,646932,155145,11338,802508,264023,632780,1044657,422451,437848,860619,336756,321332,529203,729704,502866,187378,422915,951984,232035,20328,278414,259775,142840,521957,1015955,84331,966362,483710,317224,787808,945072,906835,728946,21735,463001,84227,643464,897088) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002774s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000778s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000776s ]