SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391967 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391967 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125756,468240,439111,332337,988102,988758,983563,753183,389637,133041,112385,195173,3808,107218,746480,383831,639595,21356,661150,171488,139119,632121,746358,738236,651617,99862,953783,580588,66918,1013243,203029,818461,994944,964470,329462,329406,106772,11183,621604,973368,787095,322228,32011,973571,938220,589107,190003,27144,361723,573505,618150,524318,424003,75880,242889,179729,672507,449044,1042230,895181) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391967 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391967 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]