SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402411 LIMIT 1 [ RunTime:0.001798s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402411 [ RunTime:0.006564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (993703,102022,748781,312099,757655,721673,348470,841429,1027163,316610,749955,845866,386413,688333,777730,239032,491531,401691,361006,804008,481352,49132,600534,985452,468898,226440,180017,163506,948058,457399,580735,747921,878902,689206,851059,196579,193615,130083,179116,373345,288350,798577,652486,1005208,942068,393241,727354,388114,923412,463955,163966,516189,314699,739392,1024341,668881,772207,235682,782081,532767) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]