SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101216 LIMIT 1 [ RunTime:0.000279s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101216 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182437,504226,973089,979441,756170,391318,332378,57121,74594,752271,533777,433966,397701,170230,468038,804821,145971,708477,529040,624749,1042568,387217,1032115,574946,256378,645484,925298,806438,135139,254270,742903,178744,316030,959482,29166,852344,966455,798783,610973,663217,52692,407523,541591,334537,598304,138288,494597,543307,394942,393475,459797,559984,580169,722339,760062,186679,502050,872695,842354,505578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]