SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465801 LIMIT 1 [ RunTime:0.000515s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465801 [ RunTime:0.001922s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429296,758061,878739,711292,1046524,136782,248296,643844,1044583,613190,167236,4146,329577,527019,390454,555814,664666,28204,770044,165542,741139,289384,412313,798990,959653,760127,141412,995144,225222,561870,940138,379734,345024,983806,330038,864575,887006,403435,838450,575763,741353,465922,904068,671999,190865,328367,65752,292529,410485,949450,644191,412373,103745,666696,977776,193941,227041,338058,289178,140681) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001178s ]