SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001577s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103838 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103838 [ RunTime:0.003208s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (824827,49466,412963,406627,417158,831177,775387,463577,819271,847359,355485,622295,17900,134662,574860,855730,195862,925269,182701,907780,583162,317107,403664,795431,536037,92327,1045791,626534,15969,819409,940414,269863,967873,1014338,491658,97462,209585,267846,180345,643355,421745,627478,728013,981147,610093,326556,426139,739933,259544,900648,344876,330945,371867,488963,1044473,993047,950646,218921,462255,1013214) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002770s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001423s ]