SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 374218 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 374218 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (838539,893593,978379,317771,1029214,807486,637350,367335,1010016,544588,994564,855990,296244,221315,923547,1008609,533191,101410,695113,747046,823423,77176,461681,70993,152636,133453,90220,694369,882138,407674,999750,913499,353697,433314,384890,163784,920791,1043326,619139,309034,695536,628544,101310,978335,740051,60178,386772,852947,537840,126110,777350,573069,455014,717942,385046,128573,121763,350122,659420,151197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 374218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 374218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]