SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 982318 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 982318 [ RunTime:0.001543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (914601,102951,114360,93012,1003387,48622,916315,811117,947213,597934,617331,485766,341390,111049,996034,240636,458291,583828,124045,665813,180263,26755,839379,30317,1040360,700741,165669,319692,110254,73397,907746,183283,162724,967568,168619,936095,1010402,793751,235857,83422,627557,885677,513255,939358,110273,273554,303006,620622,444094,219831,446347,945800,1046937,824398,814580,46893,800569,101347,867841,381739) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 982318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 982318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]