SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011271 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011271 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (224739,491174,316576,985358,994489,693092,880117,434280,250662,134855,615475,432562,877481,63958,57073,895534,653406,505418,955826,145737,625948,353147,526113,519099,426137,238768,366589,992996,855983,57533,817922,537763,961405,792028,713387,323855,1013760,675414,644360,395513,638616,636040,25553,824076,496424,179253,905797,678106,584164,881811,976219,498203,1017222,1047273,424041,253086,339864,787085,783217,67515) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000911s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]