SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28691 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28691 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (823937,724004,713105,512982,371088,501058,958177,646480,711599,296335,924979,331622,734671,923370,420427,359406,928019,631730,913108,99120,743437,473411,432339,35089,1040600,1047483,755862,1012708,961083,871688,653968,517588,272641,85962,596264,1037186,305326,883499,289463,732378,499377,464194,384295,159085,637264,298862,42674,54860,723809,344154,264031,75094,988050,923234,340514,916226,805346,10430,505672,96871) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]