SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041454 LIMIT 1 [ RunTime:0.000837s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041454 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (148014,259666,411159,378568,677441,21835,156460,1016710,411185,688513,340707,1036388,19177,354930,875728,1001461,968731,261662,734423,1037803,966281,727,1007195,850689,905701,26096,413688,244706,939587,720386,1040647,212064,78726,517662,647307,242755,983654,111545,516317,353275,767711,346,570945,103991,221761,660278,98287,438504,27770,80752,882177,472267,79094,726574,291446,506627,383355,1019518,939421,363159) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041454 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041454 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]