SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330840 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330840 [ RunTime:0.002750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (62127,806247,508285,1003467,826510,244640,709920,454308,725648,500075,890486,989146,187905,315254,5763,367572,997551,51439,249125,312580,831646,533310,645898,965333,122715,714164,842318,141095,783334,915938,10836,333207,508849,740575,272879,505704,63359,483668,10194,597886,478415,668692,909214,717990,297420,396210,333958,847843,132038,173936,346285,98556,422897,653879,506814,785090,623219,137075,337878,905605) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000705s ]