SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 601191 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 601191 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (589921,104069,455116,496624,225467,60177,710208,298291,963661,473086,720873,691924,441630,36722,440495,992914,539292,189732,674425,408829,918307,827775,326817,125626,172555,25950,55588,985201,696614,775550,1023199,544685,668690,810157,103056,281925,902214,2919,81225,207518,67372,26351,917819,66237,1912,852999,580240,535461,91453,997344,34660,755225,111945,212044,704230,484402,937218,16871,925416,445562) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003823s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 601191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 601191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]