SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023762 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023762 [ RunTime:0.001509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (605286,867114,621189,553789,913170,596501,742768,630425,651373,721753,78126,126283,709528,553672,962369,473162,215381,199367,164552,539100,782491,797352,471758,721824,930487,920310,768420,601896,884524,764903,421733,263296,989304,940212,244845,94126,635641,541332,371673,404536,738678,89843,650070,378365,230335,294297,836226,1046210,764622,740507,105343,281271,367385,395130,28687,145896,645180,1044680,17850,678691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023762 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023762 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000727s ]