SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517482 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517482 [ RunTime:0.002266s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715108,233011,577905,879584,508753,204691,1022165,170270,859211,108551,66146,28692,1028829,418491,919885,686146,964983,272970,192877,670380,404910,338720,129983,85521,1008518,439002,576490,632389,878793,432165,667153,364912,254267,621950,72152,188804,137274,614904,618319,192711,825586,265774,105506,284816,623184,866669,104256,85921,1008490,12653,977278,899475,967392,689437,575413,968335,117999,511890,225788,412052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002724s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]