SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200481 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200481 [ RunTime:0.002426s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (971623,804548,926462,155961,432816,65549,863086,1024021,503178,44272,974220,361029,1047065,334310,884906,247614,870461,148901,66963,730700,315512,50929,990247,323289,124025,763264,451196,816169,707899,70745,68172,976032,803393,151508,569066,15200,843525,342811,948257,282068,134311,780512,268386,563478,429821,757608,669589,433711,607026,444919,85594,725222,228180,141104,454007,1014763,967301,1000897,348123,520207) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]