SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 249513 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 249513 [ RunTime:0.001880s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504202,391293,611814,162381,301506,833877,1020606,770298,765243,650688,664812,1004780,800251,639851,600810,396581,716219,218041,599190,236578,948631,343324,783046,477143,377170,723108,293114,169099,675872,574153,721036,70736,1000432,250342,894004,186981,98429,795242,332318,1019655,834354,573675,470890,851338,590087,388410,495719,414551,120853,402355,990385,20730,364854,640912,134521,864904,790316,757862,518056,69776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 249513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 249513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]