SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283444 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283444 [ RunTime:0.001874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (611386,498275,378952,106671,311065,548147,94204,455398,837146,286434,477395,72328,512362,745091,322514,385892,1013378,696175,231790,69482,109328,971702,40120,572199,375753,889845,146193,982541,34501,902218,433929,532366,92250,152868,213290,287386,478944,613928,141484,681738,832552,1016,847515,728336,762205,740962,887600,1000643,871239,811211,533287,372815,785837,576970,757871,702362,986989,518195,806389,573182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283444 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283444 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]