SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505391 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505391 [ RunTime:0.002620s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715102,151456,596710,914583,609736,775485,350909,247463,166498,180268,936396,613682,869643,358915,60881,508370,527318,981910,228081,307703,618149,757330,3719,718112,401972,449794,56511,503810,682632,498580,670153,157951,622852,994785,879301,694108,1012777,736004,952203,118502,102688,474726,487853,745596,576385,885413,14357,136617,663779,174748,1038841,797297,776624,901698,576281,271739,422476,824420,134495,886033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]