SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 297620 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 297620 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (348477,571493,297147,198864,932127,624366,451993,412463,34023,852462,302019,382885,33353,466701,878493,933922,1024628,902107,462429,563528,626335,856821,629208,892519,996926,542096,481793,411131,319051,109195,936584,112779,927669,1016194,281585,666085,261983,362991,39067,249273,585505,226302,19506,143050,840112,441871,390109,194251,986881,709949,70253,912490,956631,295523,984451,295456,340356,526019,836151,961522) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 297620 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 297620 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000733s ]