SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527241 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527241 [ RunTime:0.002027s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033745,438786,887227,84672,869745,467793,1041073,733987,272302,933763,233099,378298,170859,885403,448679,140982,388244,320232,844083,464375,747369,270154,37159,538579,272553,365607,119802,114997,50916,1038601,975037,669163,749184,629964,855172,144583,30005,468458,410612,724011,735539,294900,859386,543481,881607,911182,723293,905347,597087,247353,850351,815377,810019,48418,394987,579709,781963,544724,539740,604298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]