SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103863 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103863 [ RunTime:0.001549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (872661,540568,860562,256138,1033971,905120,196348,601027,815215,935364,425114,75025,220988,112788,33988,834906,77384,169284,910933,268406,936244,800364,376501,532264,225264,470148,403041,656066,147376,433735,425063,767797,304447,1022411,333808,789091,342432,296291,799970,1037394,971585,517226,589228,565190,743575,567205,993449,1011961,938459,178479,225055,260043,123393,375181,1015411,85840,381681,148997,802367,231019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103863 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103863 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]