SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431117 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431117 [ RunTime:0.002422s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (136639,10832,618168,182007,549117,148676,140918,63818,628821,163943,229524,915735,831687,160818,444606,515181,64815,73267,818295,1010053,83463,714218,503442,704177,304517,368862,95547,135581,389582,332775,672734,92269,724448,665634,441517,636417,1002437,27419,863276,402767,550260,19935,407225,989617,576293,216895,147731,774345,168828,710908,68478,606536,504809,550489,779701,741720,324005,570344,864670,22016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]