SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002577s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412712 LIMIT 1 [ RunTime:0.001577s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412712 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416438,419146,39477,657784,436414,464496,539768,919104,450318,554171,775185,90657,413259,113922,885547,874115,129261,593332,740880,371987,387776,134191,436014,134425,990564,352043,115289,885973,331875,859116,91735,792706,196895,85688,406293,284088,117292,872649,589909,254792,593578,422734,699374,478014,5297,996997,590172,613796,927365,870260,383554,277927,885736,704398,171510,512284,262128,710972,284556,199375) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000893s ]