SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 675438 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 675438 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (134317,658160,579374,124930,498939,298684,1045859,100386,995901,801314,81096,393437,519502,548840,113552,259911,785961,435608,835689,190383,446779,514155,917161,897634,804602,453966,949957,635895,284390,878497,550918,328235,927583,1044313,1043836,23234,337984,880943,274700,467747,726551,853493,113951,314087,606834,936901,529471,190792,27407,185094,237233,105139,745188,797461,640986,779531,127524,838153,276961,727195) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 675438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 675438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]