SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015140 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015140 [ RunTime:0.002794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (757088,111656,608814,157657,86357,571220,625279,384010,768629,298670,79384,949769,675079,501298,547688,118406,794807,28852,485358,711102,598143,599431,1013495,405066,607219,145543,231249,98341,911874,412268,727464,1019031,150587,231755,329298,916298,172442,325372,96634,728583,286924,475566,815948,924676,40300,54899,41354,1005549,270767,865934,1014134,515515,702100,174814,412615,121592,910067,553167,297157,1043577) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]