SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001495s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519404 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519404 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014260,25111,86302,564290,262410,1024436,178074,684019,661745,655112,861974,717651,860971,553027,29984,666908,47861,369264,35539,897997,388370,785657,158561,102151,121096,464917,138069,559368,621659,305746,425559,578352,390097,610622,392833,989389,212744,230346,25890,194865,702783,57221,940321,217162,646106,897262,257725,855514,1026577,451874,973314,770308,785138,698420,409546,513372,177016,326948,483163,522405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]