SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591534 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591534 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510572,765694,701204,493449,859902,422993,108943,1005052,428652,377522,759634,1009170,448713,374085,187660,575617,967087,79413,675740,686182,394045,363255,622388,744046,576814,241802,423125,772592,929249,289765,587356,819830,111866,925796,849013,146914,392238,468881,538989,328865,938771,564475,349662,340665,564456,225008,194501,867436,869150,1030035,28214,906832,780879,338620,735923,886266,149245,374270,1032734,754163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]