SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103807 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103807 [ RunTime:0.001471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (838499,848246,1041415,1042523,131220,680770,460653,952113,852557,157099,254191,1020667,728257,123535,940493,550237,678127,208982,410964,1005298,839125,1010077,102563,678481,946342,589156,811117,462534,341340,787644,636189,747166,21419,356809,927911,607239,542740,270320,46481,35942,465211,847990,589586,457531,873923,10199,998637,933313,953221,390029,303783,842487,372105,767870,3961,484170,222614,525249,341698,1033987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000923s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103807 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103807 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]