SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407697 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407697 [ RunTime:0.005587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (19779,416610,488083,767995,673879,33538,49654,152382,500376,193358,107483,781262,753825,1030832,851712,131288,767919,930119,981212,644521,836167,118560,602019,495486,68184,83363,971725,289273,838571,106596,615986,902904,322135,525226,955384,139040,768101,91553,787140,651242,711578,28810,831307,665166,210579,823949,788225,898241,683355,43844,572152,420829,192669,331875,952476,217077,544733,801406,932732,913709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407697 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407697 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000995s ]