SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004451s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106084 LIMIT 1 [ RunTime:0.002799s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106084 [ RunTime:0.008524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (266498,414231,990192,849320,972212,528562,58490,257652,154465,941731,844682,985950,192121,727888,956530,974447,748346,29666,905181,936137,445516,872760,44895,487839,894697,284449,722340,563847,213807,545886,330480,181908,948367,796852,100714,42829,85439,158101,278588,1045504,248548,753761,459229,685160,80360,105473,418678,805647,378529,683538,978197,694267,808662,716492,250307,907039,44788,706167,7264,1031021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002476s ]