SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001566s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047208 LIMIT 1 [ RunTime:0.000673s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047208 [ RunTime:0.001861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (918108,453706,202838,868983,377784,631218,665544,849878,1014890,997937,1022738,132467,651562,799495,309160,71268,301420,137068,928105,461834,162504,1038556,858398,754689,159126,75976,188565,617906,111933,24218,933489,329087,596094,589612,262435,5309,839469,808681,385574,281043,567235,1028728,501107,863830,767097,963968,984373,440477,725556,277432,482577,877138,948838,997003,939119,649206,892063,194719,285469,408560) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]