SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 601312 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 601312 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311954,774611,289972,742250,987377,88712,1024208,897403,755663,98030,829768,184502,522370,955567,649142,971027,825859,253453,493280,311635,427530,70745,729319,193257,660380,272943,487253,903545,262412,76214,336159,490086,959853,127885,247345,332310,614282,668453,224555,713839,463138,599851,550047,967004,831265,695182,712465,367489,584531,849559,282825,339670,431693,108423,684303,154506,430066,646197,991256,797033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 601312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 601312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]