SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 600512 LIMIT 1 [ RunTime:0.000529s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 600512 [ RunTime:0.001844s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602253,201460,981056,271210,736998,860503,110789,550394,382059,182927,583922,632354,329386,539374,820651,195112,926019,344864,823958,541106,657091,1041894,531503,1016102,473839,242942,539536,1015249,765030,956095,188916,343614,379607,311419,842258,200528,289743,256087,514129,490754,183853,677937,904865,423291,321853,844242,228296,320022,26649,930719,485003,373266,322518,381939,1023306,180118,883735,613885,593217,221146) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 600512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 600512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]