SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001557s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431078 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431078 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002496,778114,850367,607045,748230,913370,300678,808953,414531,709616,410349,618818,163155,270041,437271,503414,145134,527083,262261,403094,125918,363569,109324,22127,803272,321716,315226,705301,163725,244801,724044,58004,299931,935237,2620,208940,523285,865593,573578,380133,666584,335464,283224,337257,388009,842900,122803,929742,174185,119358,128600,239068,960356,445105,557632,996617,819368,801161,107722,728132) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]