SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51109 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51109 [ RunTime:0.003330s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (326123,310309,232891,412534,321207,724047,617329,48701,481867,852492,556357,1045330,431773,545132,857709,390976,839687,116056,693481,825054,150196,774117,986890,586661,359795,629290,891263,291690,410986,323095,73562,534485,737873,141985,640634,571718,1018165,1041802,457961,128053,918343,303797,27660,1015311,931225,99387,288123,167999,1024000,42896,612149,280175,648759,1026623,417860,135791,547017,323661,845968,19833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000696s ]