SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454104 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454104 [ RunTime:0.002556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (461263,1043058,724266,883577,726655,295013,193589,885610,583351,254001,383757,976254,661387,920115,40551,15695,996403,522650,230122,44043,402693,474427,936942,773368,963207,863954,985735,99417,909301,455673,564532,340607,198261,235125,759835,1007092,655670,30741,143837,445312,409237,54527,1005175,638876,977927,592179,699923,589624,758832,411910,708461,212233,292195,572204,101502,970843,740226,504947,209063,527498) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]