SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034087 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034087 [ RunTime:0.001738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (68236,392988,109152,999757,837481,648751,1024748,858649,658827,871340,482050,148474,236563,87762,736532,730504,876310,287014,778994,388610,110389,162691,789382,946190,1046657,983822,412431,1037448,146679,949290,759901,688470,989008,301005,159918,165478,477951,758221,633404,350180,954248,552473,288443,860417,745081,479635,617348,163169,384819,384037,1019701,737075,146614,537841,548991,894506,139992,63754,685885,215999) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034087 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034087 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]