SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422656 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422656 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (179689,977245,358608,826026,548759,53042,125525,642315,634096,894655,1022693,606747,44811,852712,614656,487283,430367,418919,468915,937680,375196,488231,318985,406135,270475,677233,913764,169804,295275,1011395,484932,746810,1021820,790874,551195,933573,1017035,500099,83739,273134,416924,255053,261029,3314,172083,335258,149320,1039395,438649,4366,730505,777017,383433,119997,752461,50906,191116,415532,151593,127760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422656 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422656 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]