SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 223688 LIMIT 1 [ RunTime:0.002026s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 223688 [ RunTime:0.003743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183173,670216,884712,398326,845510,625874,758105,795866,1009200,693280,355846,1024021,373233,97276,645014,264686,810068,102292,506593,948109,754389,1022130,424693,627200,416833,558547,871270,127416,812746,435732,758940,23910,552993,475733,43633,88700,407628,119979,1034429,1002633,672207,481626,1046917,70662,762835,840517,535494,270740,504497,498527,152832,516206,487968,689066,914228,603291,313054,166576,676041,530865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 223688 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000617s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 223688 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001062s ]