SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023341 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023341 [ RunTime:0.004210s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (720581,996636,889913,506360,979016,170119,792866,705975,855197,396434,717448,293654,606917,1004208,275078,863050,668614,786326,963017,202061,37066,99050,281457,609349,592981,847040,963130,530160,997538,1015481,495764,793685,292692,749183,383805,883695,979974,858168,851778,814355,61741,612929,754046,332880,297873,280631,508156,715762,856590,187699,458667,468201,657393,220409,309100,217128,378910,769598,387342,44372) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000602s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000736s ]