SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031037 LIMIT 1 [ RunTime:0.000649s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031037 [ RunTime:0.002591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (844022,525595,521974,510282,18487,862945,31741,835583,138686,160208,125363,660676,108830,371566,568234,461297,575101,726707,346848,286095,194347,182421,259398,869425,32822,865268,823352,811548,643263,938258,563181,514792,818795,864253,917690,1015682,227869,210994,386578,441277,172326,970010,698073,604302,100016,931536,73647,336551,831065,454026,36063,32024,280651,361621,895644,706383,699521,653312,455358,402838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031037 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031037 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003885s ]