SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047280 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047280 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (754399,174671,80912,1005570,381781,106382,25948,217853,920485,209769,316996,840006,188423,969505,219653,133592,129717,922591,760553,92975,480508,66548,529210,116263,316892,118760,276175,934709,721363,464470,182467,68284,35157,260717,677200,617010,485056,123557,344647,1027060,258216,603413,992892,445111,118225,809036,174913,714438,328578,586947,432167,198371,423731,634815,749037,1024754,71592,22545,412047,430727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]