SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104531 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104531 [ RunTime:0.003334s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (717948,853974,298245,372000,251411,834525,745846,689158,866732,1004592,190849,440170,613996,163386,783106,200673,959733,1021711,154710,576646,186835,351588,831872,871393,680017,420730,519291,1002652,656512,618782,618324,468404,459403,36508,289113,193872,606824,444772,384710,954156,1041739,192193,17193,199071,240733,655775,854858,668816,445698,688332,189439,460491,647788,196715,617816,496876,246618,16090,63294,604803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000914s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]