SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 346583 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 346583 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (881281,488405,360839,379760,467029,864035,470863,1048825,927290,565434,301468,320200,897711,393262,196741,726179,621224,114056,445803,672704,858163,574120,262383,665121,237372,275271,235473,401472,829626,555155,491639,406218,55150,36290,939567,162822,394281,621314,494420,824928,845100,571610,81182,887038,961928,697348,744475,791044,887349,296667,300,26493,1018023,659481,787666,172028,918009,196219,779079,111922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 346583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 346583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]