SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555809 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555809 [ RunTime:0.001703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (708217,1003163,786307,614007,265335,857575,299601,228835,75095,811218,304951,589545,685975,943000,900298,700154,903895,517196,119317,364328,452389,642652,977871,1043472,118550,121660,524549,631279,331625,664870,570415,11153,641055,967383,179230,970254,317760,991461,497451,869778,271002,648544,753536,409560,54815,219409,544472,514708,805250,624946,147737,378919,943053,134641,324303,723032,577171,404917,65264,341038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002199s ]