SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517685 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517685 [ RunTime:0.003335s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509029,927999,903492,934203,946876,430373,86760,338919,552499,692766,615146,971252,933260,290950,785568,30771,522269,279814,710689,423540,840881,474039,720941,35717,856153,525889,785061,98326,919311,715950,26898,196683,413286,730888,1013866,482624,1018102,109238,266010,921857,788887,657211,552129,177595,254447,744839,512359,588112,473877,627291,351492,324994,296500,127499,360711,201909,15830,684103,460095,905208) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517685 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]