SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404320 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404320 [ RunTime:0.005330s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (835463,841890,320962,680780,940513,657616,714930,743104,83581,623663,557846,326702,470234,138511,20033,657590,42248,91738,446046,84141,671918,766483,803336,733553,770738,329929,180755,142477,1031384,980506,786447,257516,1624,680595,428683,483734,499982,170498,744461,584700,368768,312407,637747,126549,638839,953207,540315,513424,209293,697839,74289,300819,260024,704749,72108,266308,430179,64669,313858,470128) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]