SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003466s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041016 LIMIT 1 [ RunTime:0.000690s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041016 [ RunTime:0.004892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (129630,279599,216007,404512,344651,1047800,842456,232706,502576,916670,561487,409648,843050,785495,121715,219989,562420,45710,520614,942291,422501,1021218,486019,216966,555484,858344,610340,480366,903621,227424,145118,362592,316170,860252,816801,402636,513037,667642,833439,313407,298817,795617,1045257,478566,740048,79021,524608,812840,663956,337997,85227,10574,893500,424991,570103,1032054,415756,1017874,225887,439484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001765s ]