SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 610552 LIMIT 1 [ RunTime:0.003614s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 610552 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71913,357708,621803,69036,231843,235742,104080,238411,979596,147170,150930,253860,587693,556545,297608,363636,520870,875428,428397,139003,71338,115924,952347,1020399,412837,211421,314542,261397,544332,79991,475786,30007,638854,1044820,526607,327413,116777,44740,260379,184423,243304,888443,484865,403625,533213,134700,582042,421928,784253,478229,900090,602667,134964,28247,889786,385111,15744,185108,391263,718001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.016928s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 610552 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 610552 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003479s ]