SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023908 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023908 [ RunTime:0.001955s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280708,496722,947088,456446,897935,848135,342984,426582,591296,512516,798464,860690,160099,24832,543017,839508,966574,496564,58144,948831,663539,102228,984154,670570,95428,246817,139090,913389,687613,502493,517702,174986,917847,39618,616325,235464,88759,937036,362328,178337,128480,305093,466686,195749,93823,747033,515452,889530,694034,545680,545264,913947,575786,635061,327610,593463,627965,272626,846753,768303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]