SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 255396 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 255396 [ RunTime:0.003696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265351,983307,714514,739025,838119,183922,237041,375716,913154,724691,981246,442680,410845,403557,583779,638874,486716,114755,565249,968607,371843,1048572,232013,541942,233832,366690,623570,202290,648231,64061,53629,487753,415868,1046048,393414,1040112,857198,1045853,6673,186293,344760,1002737,870698,1038167,102841,780575,838407,817034,573079,879720,891637,843709,422700,615866,526865,272377,900409,504920,965825,502419) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 255396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 255396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000697s ]