SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541273 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541273 [ RunTime:0.001458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (176360,477701,440694,621141,779125,941644,4133,585582,176876,735901,913542,705143,596728,292598,420136,327969,247340,749731,4555,568655,304276,567828,247979,102125,643413,605424,491085,570919,874603,878579,78370,658964,701823,1002222,1012726,905304,677788,405700,450307,963316,824180,798440,584633,646073,556070,689951,245291,1048785,710245,1007160,842675,198515,240732,166743,603543,239864,1045553,957720,312121,496755) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541273 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541273 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]