SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 116810 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 116810 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (379308,437598,579281,704013,497597,1004542,1022871,129542,797460,847278,614397,443881,265152,547145,820655,262762,646950,660723,105635,219322,399177,800734,454871,282602,994704,875635,206355,509944,498299,1023658,954519,111775,1018041,411802,698864,174570,505779,875807,1023936,109489,36056,313001,817806,574751,760882,793214,746252,1045694,246213,986011,729735,42966,802012,655829,1036684,172539,508392,260264,872700,715066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 116810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 116810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]