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` = 109138 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109138 [ RunTime:0.002037s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405502,489253,212348,482057,401539,829709,842081,809367,102936,311433,29061,1011258,662091,293147,733354,922910,731420,544291,70557,184670,398704,276654,505778,221580,971760,1011206,662592,54904,46762,627244,18747,245598,1026493,528707,438791,203554,416740,57718,827689,303847,506116,637068,9963,597641,204870,1042866,511194,121810,869865,344054,26432,590606,161517,683777,248426,998631,559464,51574,741083,468459) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001912s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]