SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546501 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546501 [ RunTime:0.002254s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (14339,614052,921015,887598,759547,555857,168757,947590,10027,618950,167738,925379,388383,604653,299749,700621,802824,656922,388041,925557,457374,346540,489837,599962,329586,883582,481230,471570,1047790,525030,124679,782395,73247,374406,981847,639188,170338,352895,860982,639363,657755,502326,736962,985877,1040167,89740,136726,93574,908830,243336,346888,859895,784783,876809,463881,487396,769010,511670,97605,53290) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001777s ]