SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 595447 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 595447 [ RunTime:0.001904s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311406,914000,144247,291685,454555,1011886,408262,564620,144763,692465,967718,826842,1017353,636970,488495,1027351,11549,904395,343716,285945,694152,561166,837134,955580,905165,408433,613523,734145,874360,58503,459029,59489,909768,22100,210877,930912,939129,1010465,215561,725740,948494,51356,158434,708694,259078,115939,997485,301168,273481,342453,535043,373725,834763,326941,210707,874859,506865,464517,422993,725302) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 595447 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 595447 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]