SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511936 LIMIT 1 [ RunTime:0.000533s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511936 [ RunTime:0.001831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (918101,328451,381456,158859,777435,128138,571145,860049,194724,804054,885432,309957,43984,297532,478585,442764,351835,210396,120388,415812,1757,626430,517516,924716,518906,591106,764430,95387,683121,322960,313388,495370,131060,660393,1046194,194879,305337,578506,807275,79049,293115,575574,297401,705952,302107,462450,471335,741550,336954,713662,467193,412242,565120,872437,539568,490688,156614,475169,677267,200542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000730s ]