SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013985 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013985 [ RunTime:0.002233s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342721,766173,169126,928414,795699,288300,962757,502193,839286,883573,737467,306500,25275,200050,23118,420638,347355,982137,131725,845280,44633,836316,430187,222275,687606,417310,215288,577937,994556,795549,81075,560227,508929,115229,658043,242928,420937,128819,339977,553846,538722,932955,626636,451853,874812,800357,650474,817636,997419,161104,623359,172230,687810,175497,357763,819257,27669,435378,987509,790776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]