SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142105 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142105 [ RunTime:0.003274s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (555951,398267,463475,858355,985900,788627,599236,957995,78763,123787,614033,809444,332294,743927,854897,978688,703707,613968,60294,271878,918278,699664,541385,982385,147941,12797,114358,359814,756799,237134,797812,5089,1038059,405686,188609,765529,768455,1010818,482032,749037,651981,1024721,394362,628235,816945,905788,425936,842979,846563,997889,783644,179627,17779,703578,122562,142024,562424,511282,185485,541706) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]